<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title>超市账单管理系统</title>
    <link rel="stylesheet" href="../css/public.css"/>
    <link rel="stylesheet" href="../css/style.css"/>
    <script type="text/javascript" src="/js/jquery-1.12.4.js"></script>
    <script type="text/javascript">
        function down() {
            var fukuan=$("#fukuan").val();
            var  tigong=$("#tigong").val();

            var index= $("#index").text()*1+1;
             var indexs=$("#indexs").text();
            var name=$("#name").val();

            var url="/BillServlet?action=fenye";
            if(index>indexs){
                alert("已经是最后一页了")
            }else {
                $.ajax({
                    type: "post",
                    url: url,
                    data: {"fukuan": fukuan, "tigong": tigong, "name": name,"index":index},
                    success: function (date) {
                        $("#index").text(index);
                        var obj = eval("(" + date + ")");
                        $(".trr").remove();
                        $.each(obj, function (i, item) {


                            $(".providerTable").append(
                                '<tr class="trr">' +
                                "<td>" + item.billCode + "</td>" +
                                "<td>" + item.productName + "</td>" +
                                "<td>" + item.providers.proName + "</td>" +
                                "<td>" + item.totalPrice + "</td>" +
                                "<td>" + item.p + "</td>" +
                                "<td>" + item.data + "</td>" +
                                "<td>" +
                                " <a href='/BillServlet?action=select&id="+item.id+"'><img src='../img/read.png' alt='查看' title='查看'/></a>" +
                                "<a href='/BillServlet?action=selec&id="+item.id+"'><img src='../img/xiugai.png' alt='修改' title='修改'/></a>" +
                                "  <a href='#' class='removeProvider' onclick='on("+item.id+")'><img src='../img/schu.png' alt='删除' title='删除'/></a>" +
                                " </td>" +
                                '</tr>'
                            );

                        });


                    },
                    error: function () {
                        alert(11);
                    }
                });
            }
        }
        function up() {
            var fukuan=$("#fukuan").val();
            var  tigong=$("#tigong").val();

            var index= $("#index").text()*1-1;
            alert(index);
            var name=$("#name").val();

            var url="/BillServlet?action=fenye";
            if(index<1){
                alert("已经是第一页了")
            }else {
                $.ajax({
                    type: "post",
                    url: url,
                    data: {"fukuan": fukuan, "tigong": tigong, "name": name,"index":index},
                    success: function (date) {


                        var obj = eval("(" + date + ")");

                        $(".trr").remove();
                        $.each(obj, function (i, item) {


                            $(".providerTable").append(
                                '<tr class="trr">' +
                                "<td>" + item.billCode + "</td>" +
                                "<td>" + item.productName + "</td>" +
                                "<td>" + item.providers.proName + "</td>" +
                                "<td>" + item.totalPrice + "</td>" +
                                "<td>" + item.p + "</td>" +
                                "<td>" + item.data + "</td>" +
                                "<td>" +
                                " <a href='/BillServlet?action=select&id="+item.id+"'><img src='../img/read.png' alt='查看' title='查看'/></a>" +
                                "<a href='/BillServlet?action=selec&id="+item.id+"'><img src='../img/xiugai.png' alt='修改' title='修改'/></a>" +
                                " <a href='#' class='removeProvider' onclick='on("+item.id+")'><img src='../img/schu.png' alt='删除' title='删除'/></a>" +
                                " </td>" +
                                '</tr>'
                            );

                        });


                    },
                    error: function () {
                        alert(11);
                    }
                });
            }
        }
        function on(id) {
            alert(id);
              $(".zhezhao").show();
           $( "#removeBi").show();
           $("#se").text(id)
        }
             function  butt() {
                  var fukuan=$("#fukuan").val();
                  var  tigong=$("#tigong").val();


                  var name=$("#name").val();

                 var url="/BillServlet?action=cha";
                 $.ajax({
                     type:"post",
                     url:url,
                     data:{"fukuan":fukuan,"tigong":tigong,"name":name},
                     success:function(date){
                         var obj = eval("(" + date + ")");

                   var count2= date.substr(date.length-3,date.length-2);
                      var count=count2.substr(0,1);

                         $("#indexs").text(count);
                         alert(count);
                         $(".trr").remove();
                         $.each(obj, function(i,item) {
                             $(".providerTable").append(
                                 '<tr class="trr">' +
                                 "<td>" + item.billCode + "</td>" +
                                 "<td>" + item.productName + "</td>" +
                                 "<td>" + item.providers.proName + "</td>" +
                                 "<td>" + item.totalPrice + "</td>" +
                                 "<td>" + item.p + "</td>" +
                                 "<td>" + item.data + "</td>" +
                                 "<td>" +
                                 " <a href='/BillServlet?action=select&id="+item.id+"'><img src='../img/read.png' alt='查看' title='查看'/></a>" +
                                 "<a href='/BillServlet?action=selec&id="+item.id+"'><img src='../img/xiugai.png' alt='修改' title='修改'/></a>" +
                                 " <a href='#' class='removeProvider' onclick='on("+item.id+")'><img src='../img/schu.png' alt='删除' title='删除'/></a>" +
                                 " </td>" +
                                 '</tr>'
                             );

                         });


                             },
                     error :function () {
                         alert(11);

                     }
                 });
             }
             function butts() {
                  var id=$("#se").text();
                var url="/BillServlet?action=delete&id="+id;
                 $.ajax({
                     type: "post",
                     url: url,
                     success:function (date) {
                         if(date>0){
                             alert("删除成功")
                             window.location.href="/BillServlet?action=bill";
                         }else {
                             alert("删除失败");
                         }
                     }
                 });
             }

        </script>
</head>
<body>
<!--头部-->
    <header class="publicHeader">
        <h1>超市账单管理系统</h1>
        <div class="publicHeaderR">
            <p><span>下午好！</span><span style="color: #fff21b"> ${user}</span> , 欢迎你！</p>
            <a href="login.html">退出</a>
        </div>
    </header>
<!--时间-->
    <section class="publicTime">
        <span id="time">2015年1月1日 11:11  星期一</span>
        <a href="#">温馨提示：为了能正常浏览，请使用高版本浏览器！（IE10+）</a>
    </section>
<!--主体内容-->
    <section class="publicMian ">
        <div class="left">
            <h2 class="leftH2"><span class="span1"></span>功能列表 <span></span></h2>
            <nav>
                <ul class="list">
                    <li id="active"><a href="/BillServlet?action=bill">账单管理</a></li>
                    <li><a href="providerList.html">供应商管理</a></li>
                    <li><a href="../userList.html">用户管理</a></li>
                    <li><a href="/UserServlet?action=updates">密码修改</a></li>
                    <li><a href="login.html">退出系统</a></li>
                </ul>
            </nav>
        </div>
        <div class="right">
            <div class="location">
                <strong>你现在所在的位置是:</strong>
                <span>账单管理页面</span>
            </div>
            <div class="search">
                <span>商品名称：</span>
                <input id="name" type="text" placeholder="请输入商品的名称"/>
                
                <span>供应商：</span>
                <select name="tigong" id="tigong" >
                    <option value="0">--请选择--</option>
                    <#list listg as item>
                    <option value="${item.proName}">${item.proName}</option>

                    </#list>
                </select>

                <span>是否付款：</span>
                <select name="fukuan" id="fukuan">
                    <option value="3">--请选择--</option>
                    <option value="1">已付款</option>
                    <option value="0">未付款</option>
                </select>

                <input type="button" onclick="butt()" value="查询"/>
                <a href="/BillServlet?action=insert">添加订单</a>
            </div>
            <!--账单表格 样式和供应商公用-->
            <table class="providerTable" cellpadding="0" cellspacing="0">
                <tr class="firstTr">
                    <th width="10%">账单编码</th>
                    <th width="20%">商品名称</th>
                    <th width="10%">供应商</th>
                    <th width="10%">账单金额</th>
                    <th width="10%">是否付款</th>
                    <th width="10%">创建时间</th>
                    <th width="30%">操作</th>
                </tr>
                <#list list as item>
                <tr class="trr">
                    <td>${item.billCode}</td>
                    <td>${item.productName}</td>
                    <td>${item.providers.proName}</td>
                    <td>${item.totalPrice}</td>
                    <td>${item.p}</td>
                    <td>${item.data}</td>
                    <td>
                        <a href="/BillServlet?action=select&id=${item.id}"><img src="../img/read.png" alt="查看" title="查看"/></a>
                        <a href="/BillServlet?action=selec&id=${item.id}"><img src="../img/xiugai.png" alt="修改" title="修改"/></a>
                        <a href="#" class="removeBill" onclick='on(${item.id})'><img src="../img/schu.png" alt="删除" title="删除"/></a>
                    </td>
                </tr>
                </#list>
            </table>
            <br>
            <br><p id="se" hidden></p>
            <br>
            <a href="#" style="margin-left: 1400px ;color: #0a5eb6" onclick="up()">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a  href="#" style="color: #0a5eb6" onclick="down()" >下一页</a>
            <p id="index" hidden>${index}</p>  <p id="indexs" hidden>${count}</p>
        </div>
    </section>

<!--点击删除按钮后弹出的页面-->
<div class="zhezhao"></div>
<div class="remove" id="removeBi">
    <div class="removerChid">
        <h2>提示</h2>
        <div class="removeMain">
            <p>你确定要删除该订单吗？</p>
            <a href="#"  onclick="butts()" id="yes">确定</a>
            <a href="#" id="no">取消</a>
        </div>
    </div>
</div>

    <footer class="footer">
        版权归北大青鸟
    </footer>

<script src="../js/jquery.js"></script>
<script src="../js/js.js"></script>
<script src="../js/time.js"></script>

</body>
</html>